David Joyeuse
David Joyeuse
Reactions
-
Re: Form default to today's date
Hi @Phil Wightman If you want to note the date of the submitted form, I'd rather suggest you to use an automated cell "date created". Having an hidden field in the form that as this formula…1 · -
Re: Add x months to a date
Hi @Lockie Stewart-Baker According to your screenshot, you could use this formula in the next inspection date. =IF((MONTH([Inspection Date]@row) + VALUE(LEFT([Inspection Interval]@row, FIND(" &q…2 · -
Re: Identifying Duplicates
@Nancy Heater Problem lies in the way your store column is constructed. Sometimes, it is seen as numbers, and other times it is seen as text. Formula works perfectly fine when dealing with numbers bu…1 · -
Re: How to compute Index Match and pull tolerance in a formula
Hi @Isaac Gallardo Try this: USL-PEC column: =IFERROR(100 + VALUE(INDEX(COLLECT({INJ - Critical Tolerances - USL}, {INJ - Critical Tolerances - Platform}, Platform@row, {INJ - Critical Tolerances - P…1 · -
Re: Entire Workspace Automation
Hi @Diego Casillas Zaragoza Automation works using rows. So there's no straight way to email a full sheet at a certain time. Still I believe there could be some workaround for this. I haven't tested …1 ·
